if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sp_NhomHang_Update]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sp_NhomHang_Update]
GO
CREATE PROC [sp_NhomHang_Update]
	@id				int,
	@ten			nvarchar(100),
	@maNganhHang	int,
	@thue			float,
	@ChietKhau		float,
	@ghiChu			nvarchar(500)
AS
BEGIN
	UPDATE NhomHang
		SET
			Ten=@ten, 
			Ma_nganh_hang=@maNganhHang, 
			Thue=@thue, 
			Chiet_khau=@ChietKhau,
			Ghi_chu=@ghiChu
		WHERE ID=@id
END